//add fcounty for Kentucky
// fips codes accessed here: https://www.nrcs.usda.gov/wps/portal/nrcs/detail/national/home/?cid=nrcs143_013697
gen fcounty=.
replace fcounty=1 if county=="Adair" & state=="Kentucky"
replace fcounty=3 if county=="Allen" & state=="Kentucky"
replace fcounty=5 if county=="Anderson" & state=="Kentucky"
replace fcounty=7 if county=="Ballard" & state=="Kentucky"
replace fcounty=9 if county=="Barren" & state=="Kentucky"
replace fcounty=11 if county=="Bath" & state=="Kentucky"
replace fcounty=13 if county=="Bell" & state=="Kentucky"
replace fcounty=15 if county=="Boone" & state=="Kentucky"
replace fcounty=17 if county=="Bourbon" & state=="Kentucky"
replace fcounty=19 if county=="Boyd" & state=="Kentucky"
replace fcounty=21 if county=="Boyle" & state=="Kentucky"
replace fcounty=23 if county=="Bracken" & state=="Kentucky"
replace fcounty=25 if county=="Breathitt" & state=="Kentucky"
replace fcounty=27 if county=="Breckinridge" & state=="Kentucky"
replace fcounty=29 if county=="Bullitt" & state=="Kentucky"
replace fcounty=31 if county=="Butler" & state=="Kentucky"
replace fcounty=33 if county=="Caldwell" & state=="Kentucky"
replace fcounty=35 if county=="Calloway" & state=="Kentucky"
replace fcounty=37 if county=="Campbell" & state=="Kentucky"
replace fcounty=39 if county=="Carlisle" & state=="Kentucky"
replace fcounty=41 if county=="Carroll" & state=="Kentucky"
replace fcounty=43 if county=="Carter" & state=="Kentucky"
replace fcounty=45 if county=="Casey" & state=="Kentucky"
replace fcounty=47 if county=="Christian" & state=="Kentucky"
replace fcounty=49 if county=="Clark" & state=="Kentucky"
replace fcounty=51 if county=="Clay" & state=="Kentucky"
replace fcounty=53 if county=="Clinton" & state=="Kentucky"
replace fcounty=55 if county=="Crittenden" & state=="Kentucky"
replace fcounty=57 if county=="Cumberland" & state=="Kentucky"
replace fcounty=59 if county=="Daviess" & state=="Kentucky"
replace fcounty=61 if county=="Edmonson" & state=="Kentucky"
replace fcounty=63 if county=="Elliott" & state=="Kentucky"
replace fcounty=65 if county=="Estill" & state=="Kentucky"
replace fcounty=67 if county=="Fayette" & state=="Kentucky"
replace fcounty=69 if county=="Fleming" & state=="Kentucky"
replace fcounty=71 if county=="Floyd" & state=="Kentucky"
replace fcounty=73 if county=="Franklin" & state=="Kentucky"
replace fcounty=75 if county=="Fulton" & state=="Kentucky"
replace fcounty=77 if county=="Gallatin" & state=="Kentucky"
replace fcounty=79 if county=="Garrard" & state=="Kentucky"
replace fcounty=81 if county=="Grant" & state=="Kentucky"
replace fcounty=83 if county=="Graves" & state=="Kentucky"
replace fcounty=85 if county=="Grayson" & state=="Kentucky"
replace fcounty=87 if county=="Green" & state=="Kentucky"
replace fcounty=89 if county=="Greenup" & state=="Kentucky"
replace fcounty=91 if county=="Hancock" & state=="Kentucky"
replace fcounty=93 if county=="Hardin" & state=="Kentucky"
replace fcounty=95 if county=="Harlan" & state=="Kentucky"
replace fcounty=97 if county=="Harrison" & state=="Kentucky"
replace fcounty=99 if county=="Hart" & state=="Kentucky"
replace fcounty=101 if county=="Henderson" & state=="Kentucky"
replace fcounty=103 if county=="Henry" & state=="Kentucky"
replace fcounty=105 if county=="Hickman" & state=="Kentucky"
replace fcounty=107 if county=="Hopkins" & state=="Kentucky"
replace fcounty=109 if county=="Jackson" & state=="Kentucky"
replace fcounty=111 if county=="Jefferson" & state=="Kentucky"
replace fcounty=113 if county=="Jessamine" & state=="Kentucky"
replace fcounty=115 if county=="Johnson" & state=="Kentucky"
replace fcounty=117 if county=="Kenton" & state=="Kentucky"
replace fcounty=119 if county=="Knott" & state=="Kentucky"
replace fcounty=121 if county=="Knox" & state=="Kentucky"
replace fcounty=123 if county=="Larue" & state=="Kentucky"
replace fcounty=125 if county=="Laurel" & state=="Kentucky"
replace fcounty=127 if county=="Lawrence" & state=="Kentucky"
replace fcounty=129 if county=="Lee" & state=="Kentucky"
replace fcounty=131 if county=="Leslie" & state=="Kentucky"
replace fcounty=133 if county=="Letcher" & state=="Kentucky"
replace fcounty=135 if county=="Lewis" & state=="Kentucky"
replace fcounty=137 if county=="Lincoln" & state=="Kentucky"
replace fcounty=139 if county=="Livingston" & state=="Kentucky"
replace fcounty=141 if county=="Logan" & state=="Kentucky"
replace fcounty=143 if county=="Lyon" & state=="Kentucky"
replace fcounty=145 if county=="McCracken" & state=="Kentucky"
replace fcounty=147 if county=="McCreary" & state=="Kentucky"
replace fcounty=149 if county=="McLean" & state=="Kentucky"
replace fcounty=151 if county=="Madison" & state=="Kentucky"
replace fcounty=153 if county=="Magoffin" & state=="Kentucky"
replace fcounty=155 if county=="Marion" & state=="Kentucky"
replace fcounty=157 if county=="Marshall" & state=="Kentucky"
replace fcounty=159 if county=="Martin" & state=="Kentucky"
replace fcounty=161 if county=="Mason" & state=="Kentucky"
replace fcounty=163 if county=="Meade" & state=="Kentucky"
replace fcounty=165 if county=="Menifee" & state=="Kentucky"
replace fcounty=167 if county=="Mercer" & state=="Kentucky"
replace fcounty=169 if county=="Metcalfe" & state=="Kentucky"
replace fcounty=171 if county=="Monroe" & state=="Kentucky"
replace fcounty=173 if county=="Montgomery" & state=="Kentucky"
replace fcounty=175 if county=="Morgan" & state=="Kentucky"
replace fcounty=177 if county=="Muhlenberg" & state=="Kentucky"
replace fcounty=179 if county=="Nelson" & state=="Kentucky"
replace fcounty=181 if county=="Nicholas" & state=="Kentucky"
replace fcounty=183 if county=="Ohio" & state=="Kentucky"
replace fcounty=185 if county=="Oldham" & state=="Kentucky"
replace fcounty=187 if county=="Owen" & state=="Kentucky"
replace fcounty=189 if county=="Owsley" & state=="Kentucky"
replace fcounty=191 if county=="Pendelton" & state=="Kentucky"
replace fcounty=193 if county=="Perry" & state=="Kentucky"
replace fcounty=195 if county=="Pike" & state=="Kentucky"
replace fcounty=197 if county=="Powell" & state=="Kentucky"
replace fcounty=199 if county=="Pulaski" & state=="Kentucky"
replace fcounty=201 if county=="Robertson" & state=="Kentucky"
replace fcounty=203 if county=="Rockcastle" & state=="Kentucky"
replace fcounty=205 if county=="Rowan" & state=="Kentucky"
replace fcounty=207 if county=="Russell" & state=="Kentucky"
replace fcounty=209 if county=="Scott" & state=="Kentucky"
replace fcounty=211 if county=="Shelby" & state=="Kentucky"
replace fcounty=213 if county=="Simpson" & state=="Kentucky"
replace fcounty=215 if county=="Spencer" & state=="Kentucky"
replace fcounty=217 if county=="Taylor" & state=="Kentucky"
replace fcounty=219 if county=="Todd" & state=="Kentucky"
replace fcounty=221 if county=="Trigg" & state=="Kentucky"
replace fcounty=223 if county=="Trimble" & state=="Kentucky"
replace fcounty=225 if county=="Union" & state=="Kentucky"
replace fcounty=227 if county=="Warren" & state=="Kentucky"
replace fcounty=229 if county=="Washington" & state=="Kentucky"
replace fcounty=231 if county=="Wayne" & state=="Kentucky"
replace fcounty=233 if county=="Webster" & state=="Kentucky"
replace fcounty=235 if county=="Whitley" & state=="Kentucky"
replace fcounty=237 if county=="Wolfe" & state=="Kentucky"
replace fcounty=239 if county=="Woodford" & state=="Kentucky"


